Compression aware physical database design
نویسندگان
چکیده
منابع مشابه
Compression Aware Physical Database Design
Modern RDBMSs support the ability to compress data using methods such as null suppression and dictionary encoding. Data compression offers the promise of significantly reducing storage requirements and improving I/O performance for decision support queries. However, compression can also slow down update and query performance due to the CPU costs of compression and decompression. In this paper, ...
متن کاملPhysical Database Design and Performance
Describe the physical database design process, its objectives, and its deliverables. Choose storage formats for attributes from a logical data model. Select an appropriate file organization by balancing various important design factors. Describe three important types of file organization. Describe the purpose of indexes and the important considerations in selecting attributes to be in...
متن کاملConstrained Dynamic Physical Database Design
Physical design has always been an important part of database administration. Today’s commercial database management systems offer physical design tools, which recommend a physical design for a given workload. However, these tools work only with static workloads and ignore the fact that workloads, and physical designs, may change over time. Research has now begun to focus on dynamic physical de...
متن کاملAutomating Physical Database Design Automating Physical Database Design: An Extensible Approach
In a high-level query language such as SQL, queries yield the same result no matter how the logical schema is physically implemented. Nevertheless, a query's cost can vary by orders of magnitude among di erent physical implementations of the same logical schema, even with the most modern query optimizers. Therefore, designing a low-cost physical implementation is an important pragmatic problem|...
متن کاملPhysical Database Design for an Object-Oriented Database System
Object oriented database systems typically o er a variety of structuring capabilities to model complex objects This exibility together with type or class hierarchies and computed attributes methods poses a high demand on the physical design of object oriented databases Similar to traditional databases it is hardly ever true that the conceptual structure of the database is also a good that is e ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: Proceedings of the VLDB Endowment
سال: 2011
ISSN: 2150-8097
DOI: 10.14778/2021017.2021023